﻿CREATE procedure [dbo].[FC_Usuario_Login]
@Username varchar(50),
@Password varchar(50)
as
begin
	select U.IdUsuario, U.IdRole, R.DesRole, U.Username, U.Name, U.IdEntityF, c.DesEntity, U.Active 
	from dbo.FC_User U, FC_Role R, FC_Entity C
	where U.IdRole=R.idRole and U.IdEntityF = C.IdEntityF and Username = @Username and Password = @Password
end

